MySQL database connection error 9002 (28000)

您所在的位置:网站首页 mysql 9002 MySQL database connection error 9002 (28000)

MySQL database connection error 9002 (28000)

2023-08-31 10:13| 来源: 网络整理| 查看: 265

Hi echhhh,

Can you please ensure that the value passed with the -p is the name of the database and not the password for the database.

Here is a screen capture as an example, where I am using the Azure Portal:

And when using MySQL Workbench, use the Test Connection functionality to make sure your configuration is correct.

Example when you do not have the correct client Public IP:

Example when you have the correct client Public IP and the configuration is correct. Host and User need to be changed and the password added to the vautl, if you choose to save the password:

So, I think the issue is the `-p ` being passed in your statement. If you added your user password, you should have received an error that the database name could not be found and the database name it was attempting to resolve is the same as the password value you entered. With Azure Database for MySQL, the value should be `sys`. 

mysql -h mydemoserver.mysql.database.azure.com -u myadmin@mydemoserver -p

Should be:

mysql -h mydemoserver.mysql.database.azure.com -u myadmin@mydemoserver -p sys

Please try this with a value of `-p sys`.

Regards,

Mike



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3